﻿// SilverlightDesktop.Net - http://www.SilverlightDesktop.net
// Copyright (c) 2008
// by SilverlightDesktop.Net
//
// Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated 
// documentation files (the "Software"), to deal in the Software without restriction, including without limitation 
// the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and 
// to permit persons to whom the Software is furnished to do so, subject to the following conditions:
//
// The above copyright notice and this permission notice shall be included in all copies or substantial portions 
// of the Software.
//
// THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED 
// TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL 
// THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF
// CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER 
// DEALINGS IN THE SOFTWARE.

using System.Linq;
using System;

namespace SilverlightDesktopCore.DAL
{
    public partial class SilverlightDesktopDAL : System.Data.Linq.DataContext
    {
        partial void InsertSilverlightDesktopUser(SilverlightDesktopUser instance)
        {
            if (DuplicateUser(instance))
            {
                throw new Exception("User Name is already used");
            }

            ExecuteDynamicInsert(instance);
        }

        partial void UpdateSilverlightDesktopUser(SilverlightDesktopUser instance)
        {
            if (DuplicateUser(instance))
            {
                throw new Exception("User Name is already used");
            }

            ExecuteDynamicUpdate(instance);
        }

        private bool DuplicateUser(SilverlightDesktopUser instance)
        {
            bool UserExists = false;

            SilverlightDesktopDAL SilverlightDesktopDAL = new SilverlightDesktopDAL();

            var results = from Users in SilverlightDesktopDAL.SilverlightDesktopUsers
                          where Users.UserName == instance.UserName.Trim() &
                          Users.UserID != instance.UserID
                          select Users;

            if (results.Count() > 0)
            {
                UserExists = true;
            }

            return UserExists;
        }

        partial void InsertSilverlightDesktopModule(SilverlightDesktopModule instance)
        {
            if (instance.uninstall == null)
            {
                instance.uninstall = "";
            }

            if (
                instance.AssemblyName == null ||
                instance.ClassName == null ||
                instance.IconName == null ||
                instance.ModuleDescription == null ||
                instance.ModuleName == null ||
                instance.Role == null 
                )
            {
                throw new Exception("Fields cannot be null");
            }

            ExecuteDynamicInsert(instance);
        }
    }
}